agoda_data_profiling

Dataset statistics

Number of variables	42
Number of observations	46927
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	13.5 MiB
Average record size in memory	301.0 B

Variable types

Numeric	20
DateTime	1
Text	2
Categorical	14
Boolean	5

Alerts

`booking_datetime` is highly overall correlated with `checkin_date` and 2 other fields	High correlation
`checkin_date` is highly overall correlated with `booking_datetime` and 1 other fields	High correlation
`checkout_date` is highly overall correlated with `booking_datetime` and 1 other fields	High correlation
`hotel_star_rating` is highly overall correlated with `price_per_guest_per_night`	High correlation
`no_of_adults` is highly overall correlated with `no_of_room` and 1 other fields	High correlation
`no_of_room` is highly overall correlated with `no_of_adults`	High correlation
`origin_country_code` is highly overall correlated with `original_payment_currency`	High correlation
`language` is highly overall correlated with `original_payment_currency`	High correlation
`original_selling_amount` is highly overall correlated with `amount_nights` and 1 other fields	High correlation
`distance_booking_checkin` is highly overall correlated with `booking_datetime`	High correlation
`amount_guests` is highly overall correlated with `no_of_adults`	High correlation
`amount_nights` is highly overall correlated with `original_selling_amount`	High correlation
`price_per_guest_per_night` is highly overall correlated with `hotel_star_rating` and 1 other fields	High correlation
`original_payment_currency` is highly overall correlated with `origin_country_code` and 1 other fields	High correlation
`request_nonesmoke` is highly overall correlated with `has_request`	High correlation
`request_highfloor` is highly overall correlated with `has_request`	High correlation
`request_largebed` is highly overall correlated with `has_request`	High correlation
`has_request` is highly overall correlated with `request_nonesmoke` and 2 other fields	High correlation
`no_of_extra_bed` is highly imbalanced (96.1%)	Imbalance
`original_payment_method` is highly imbalanced (58.3%)	Imbalance
`original_payment_type` is highly imbalanced (91.4%)	Imbalance
`request_latecheckin` is highly imbalanced (88.8%)	Imbalance
`request_highfloor` is highly imbalanced (57.6%)	Imbalance
`request_twinbeds` is highly imbalanced (56.0%)	Imbalance
`request_airport` is highly imbalanced (96.0%)	Imbalance
`request_earlycheckin` is highly imbalanced (86.3%)	Imbalance
`original_selling_amount` is highly skewed (γ1 = 36.55009602)	Skewed
`h_booking_id` has unique values	Unique
`hotel_star_rating` has 2060 (4.4%) zeros	Zeros
`accommadation_type_name` has 938 (2.0%) zeros	Zeros
`no_of_children` has 42690 (91.0%) zeros	Zeros

Reproduction

Analysis started	2023-06-08 14:32:27.992204
Analysis finished	2023-06-08 14:33:38.842265
Duration	1 minute and 10.85 seconds
Software version	ydata-profiling vv4.2.0
Download configuration	config.json

h_booking_id
Real number (ℝ)

Distinct	46927
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-1.7482761 × 10¹⁶

Minimum	-9.2231941 × 10¹⁸
Maximum	9.2233383 × 10¹⁸
Zeros	0
Zeros (%)	0.0%
Negative	23545
Negative (%)	50.2%
Memory size	366.7 KiB

Quantile statistics

Minimum	-9.2231941 × 10¹⁸
5-th percentile	-8.3231332 × 10¹⁸
Q1	-4.6146133 × 10¹⁸
median	-3.2064787 × 10¹⁶
Q3	4.5760991 × 10¹⁸
95-th percentile	8.2846133 × 10¹⁸
Maximum	9.2233383 × 10¹⁸
Range	-2.1169456 × 10¹⁴
Interquartile range (IQR)	9.1907124 × 10¹⁸

Descriptive statistics

Standard deviation	5.3247643 × 10¹⁸
Coefficient of variation (CV)	-304.57227
Kurtosis	-1.1991323
Mean	-1.7482761 × 10¹⁶
Median Absolute Deviation (MAD)	4.5955943 × 10¹⁸
Skewness	0.0033792406
Sum	-8.756789 × 10¹⁸
Variance	2.8353114 × 10³⁷
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
7.861445259 × 10¹⁸	1	< 0.1%
-5.859385366 × 10¹⁸	1	< 0.1%
4.102580392 × 10¹⁸	1	< 0.1%
1.795941529 × 10¹⁸	1	< 0.1%
-5.721949141 × 10¹⁸	1	< 0.1%
-4.284526584 × 10¹⁸	1	< 0.1%
2.103613272 × 10¹⁸	1	< 0.1%
5.236811047 × 10¹⁸	1	< 0.1%
-2.3832694 × 10¹⁸	1	< 0.1%
-2.788888768 × 10¹⁸	1	< 0.1%
Other values (46917)	46917	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-9.223194056 × 10¹⁸	1	< 0.1%
-9.222713784 × 10¹⁸	1	< 0.1%
-9.222411208 × 10¹⁸	1	< 0.1%
-9.222220846 × 10¹⁸	1	< 0.1%
-9.220467519 × 10¹⁸	1	< 0.1%
-9.219746746 × 10¹⁸	1	< 0.1%
-9.219730436 × 10¹⁸	1	< 0.1%
-9.219588531 × 10¹⁸	1	< 0.1%
-9.219312947 × 10¹⁸	1	< 0.1%
-9.219139934 × 10¹⁸	1	< 0.1%

Value	Count	Frequency (%)
9.223338324 × 10¹⁸	1	< 0.1%
9.223221736 × 10¹⁸	1	< 0.1%
9.222651807 × 10¹⁸	1	< 0.1%
9.222015612 × 10¹⁸	1	< 0.1%
9.221958225 × 10¹⁸	1	< 0.1%
9.221798878 × 10¹⁸	1	< 0.1%
9.221611986 × 10¹⁸	1	< 0.1%
9.221457559 × 10¹⁸	1	< 0.1%
9.220807687 × 10¹⁸	1	< 0.1%
9.220787994 × 10¹⁸	1	< 0.1%

booking_datetime
Real number (ℝ)

Distinct	357
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	199.2134

Minimum	1
Maximum	365
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	366.7 KiB

Quantile statistics

Minimum	1
5-th percentile	95
Q1	180
median	206
Q3	234
95-th percentile	262
Maximum	365
Range	364
Interquartile range (IQR)	54

Descriptive statistics

Standard deviation	49.987481
Coefficient of variation (CV)	0.2509243
Kurtosis	1.8416776
Mean	199.2134
Median Absolute Deviation (MAD)	27
Skewness	-1.0796464
Sum	9348487
Variance	2498.7483
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
183	541	1.2%
184	526	1.1%
186	505	1.1%
205	505	1.1%
199	500	1.1%
185	497	1.1%
213	491	1.0%
187	491	1.0%
193	490	1.0%
197	488	1.0%
Other values (347)	41893	89.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	8	< 0.1%
2	10	< 0.1%
3	9	< 0.1%
4	3	< 0.1%
5	9	< 0.1%
6	5	< 0.1%
7	10	< 0.1%
8	16	< 0.1%
9	17	< 0.1%
10	12	< 0.1%

Value	Count	Frequency (%)
365	11	< 0.1%
364	3	< 0.1%
363	4	< 0.1%
362	5	< 0.1%
361	8	< 0.1%
360	5	< 0.1%
359	1	< 0.1%
358	3	< 0.1%
357	7	< 0.1%
356	2	< 0.1%

checkin_date
Real number (ℝ)

Distinct	105
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	226.65112

Minimum	158
Maximum	272
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	366.7 KiB

Quantile statistics

Minimum	158
5-th percentile	186
Q1	205
median	226
Q3	250
95-th percentile	267
Maximum	272
Range	114
Interquartile range (IQR)	45

Descriptive statistics

Standard deviation	26.196808
Coefficient of variation (CV)	0.11558208
Kurtosis	-1.1697685
Mean	226.65112
Median Absolute Deviation (MAD)	23
Skewness	0.0039606809
Sum	10636057
Variance	686.27273
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
209	864	1.8%
258	801	1.7%
208	784	1.7%
230	784	1.7%
265	771	1.6%
251	748	1.6%
188	705	1.5%
223	691	1.5%
216	669	1.4%
195	666	1.4%
Other values (95)	39444	84.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
158	1	< 0.1%
166	1	< 0.1%
167	1	< 0.1%
168	1	< 0.1%
172	5	< 0.1%
173	3	< 0.1%
174	7	< 0.1%
175	13	< 0.1%
176	14	< 0.1%
177	15	< 0.1%

Value	Count	Frequency (%)
272	482	1.0%
271	515	1.1%
270	406	0.9%
269	419	0.9%
268	427	0.9%
267	436	0.9%
266	547	1.2%
265	771	1.6%
264	647	1.4%
263	495	1.1%

checkout_date
Real number (ℝ)

Distinct	91
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	228.64479

Minimum	183
Maximum	273
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	366.7 KiB

Quantile statistics

Minimum	183
5-th percentile	188
Q1	207
median	229
Q3	252
95-th percentile	269
Maximum	273
Range	90
Interquartile range (IQR)	45

Descriptive statistics

Standard deviation	26.114705
Coefficient of variation (CV)	0.11421518
Kurtosis	-1.1822042
Mean	228.64479
Median Absolute Deviation (MAD)	23
Skewness	0.0061513478
Sum	10729614
Variance	681.97779
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
210	999	2.1%
231	868	1.8%
259	843	1.8%
273	792	1.7%
189	784	1.7%
196	781	1.7%
266	774	1.6%
217	773	1.6%
252	763	1.6%
238	732	1.6%
Other values (81)	38818	82.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
183	504	1.1%
184	409	0.9%
185	413	0.9%
186	403	0.9%
187	424	0.9%
188	484	1.0%
189	784	1.7%
190	423	0.9%
191	402	0.9%
192	383	0.8%

Value	Count	Frequency (%)
273	792	1.7%
272	554	1.2%
271	444	0.9%
270	457	1.0%
269	454	1.0%
268	466	1.0%
267	661	1.4%
266	774	1.6%
265	552	1.2%
264	420	0.9%

hotel_id
Real number (ℝ)

Distinct	24969
Distinct (%)	53.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1341712.9

Minimum	1
Maximum	5823993
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	366.7 KiB

Quantile statistics

Minimum	1
5-th percentile	10917.6
Q1	255829
median	798535
Q3	2284662
95-th percentile	4168202
Maximum	5823993
Range	5823992
Interquartile range (IQR)	2028833

Descriptive statistics

Standard deviation	1361519.7
Coefficient of variation (CV)	1.0147624
Kurtosis	0.077266214
Mean	1341712.9
Median Absolute Deviation (MAD)	675419
Skewness	1.0483226
Sum	6.296256 × 10¹⁰
Variance	1.853736 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6452	273	0.6%
461790	54	0.1%
304294	46	0.1%
3080111	42	0.1%
337607	36	0.1%
185945	34	0.1%
1603143	34	0.1%
43450	33	0.1%
4426497	32	0.1%
1270365	32	0.1%
Other values (24959)	46311	98.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	2	< 0.1%
16	2	< 0.1%
75	2	< 0.1%
85	1	< 0.1%
99	3	< 0.1%
122	2	< 0.1%
140	1	< 0.1%
148	1	< 0.1%
153	1	< 0.1%
168	4	< 0.1%

Value	Count	Frequency (%)
5823993	1	< 0.1%
5808200	1	< 0.1%
5799579	1	< 0.1%
5798032	1	< 0.1%
5797970	1	< 0.1%
5795465	1	< 0.1%
5790845	1	< 0.1%
5785518	1	< 0.1%
5771209	1	< 0.1%
5761104	1	< 0.1%

hotel_country_code
Real number (ℝ)

Distinct	126
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	76.486756

Minimum	0
Maximum	125
Zeros	380
Zeros (%)	0.8%
Negative	0
Negative (%)	0.0%
Memory size	366.7 KiB

Quantile statistics

Minimum	0
5-th percentile	24
Q1	57
median	80
Q3	109
95-th percentile	118
Maximum	125
Range	125
Interquartile range (IQR)	52

Descriptive statistics

Standard deviation	31.100448
Coefficient of variation (CV)	0.4066122
Kurtosis	-0.83994882
Mean	76.486756
Median Absolute Deviation (MAD)	29
Skewness	-0.24798175
Sum	3589294
Variance	967.2379
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
57	7357	15.7%
109	6331	13.5%
80	6136	13.1%
114	4062	8.7%
49	2883	6.1%
61	2718	5.8%
92	2128	4.5%
121	2105	4.5%
118	1445	3.1%
45	1295	2.8%
Other values (116)	10467	22.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	380	0.8%
1	2	< 0.1%
2	4	< 0.1%
3	10	< 0.1%
4	114	0.2%
5	835	1.8%
6	1	< 0.1%
7	6	< 0.1%
8	3	< 0.1%
9	5	< 0.1%

Value	Count	Frequency (%)
125	4	< 0.1%
124	3	< 0.1%
123	115	0.2%
122	2	< 0.1%
121	2105	4.5%
120	4	< 0.1%
119	1	< 0.1%
118	1445	3.1%
117	1	< 0.1%
116	18	< 0.1%

hotel_live_date
Date

Distinct	17476
Distinct (%)	37.2%
Missing	0
Missing (%)	0.0%
Memory size	366.7 KiB

Minimum	1999-09-09 00:00:00
Maximum	2019-04-18 10:17:00

Histogram

Histogram with fixed size bins (bins=50)

hotel_star_rating
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	11
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.2239968

Minimum	-1
Maximum	5
Zeros	2060
Zeros (%)	4.4%
Negative	1
Negative (%)	< 0.1%
Memory size	366.7 KiB

Quantile statistics

Minimum	-1
5-th percentile	1
Q1	3
median	3
Q3	4
95-th percentile	5
Maximum	5
Range	6
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.1722628
Coefficient of variation (CV)	0.36360543
Kurtosis	0.72713638
Mean	3.2239968
Median Absolute Deviation (MAD)	1
Skewness	-0.79401111
Sum	151292.5
Variance	1.3742
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
3	14061	30.0%
4	12531	26.7%
5	5053	10.8%
2	5018	10.7%
3.5	3389	7.2%
0	2060	4.4%
2.5	1752	3.7%
1	1342	2.9%
4.5	1174	2.5%
1.5	546	1.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-1	1	< 0.1%
0	2060	4.4%
1	1342	2.9%
1.5	546	1.2%
2	5018	10.7%
2.5	1752	3.7%
3	14061	30.0%
3.5	3389	7.2%
4	12531	26.7%
4.5	1174	2.5%

Value	Count	Frequency (%)
5	5053	10.8%
4.5	1174	2.5%
4	12531	26.7%
3.5	3389	7.2%
3	14061	30.0%
2.5	1752	3.7%
2	5018	10.7%
1.5	546	1.2%
1	1342	2.9%
0	2060	4.4%

accommadation_type_name
Real number (ℝ)

Distinct	22
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	10.395785

Minimum	0
Maximum	21
Zeros	938
Zeros (%)	2.0%
Negative	0
Negative (%)	0.0%
Memory size	366.7 KiB

Quantile statistics

Minimum	0
5-th percentile	5
Q1	10
median	10
Q3	10
95-th percentile	16
Maximum	21
Range	21
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	3.1764249
Coefficient of variation (CV)	0.30554931
Kurtosis	2.770737
Mean	10.395785
Median Absolute Deviation (MAD)	0
Skewness	0.1664497
Sum	487843
Variance	10.089675
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=22)

Value	Count	Frequency (%)
10	34255	73.0%
16	4553	9.7%
5	2319	4.9%
9	2075	4.4%
19	1180	2.5%
0	938	2.0%
14	454	1.0%
17	278	0.6%
3	270	0.6%
18	238	0.5%
Other values (12)	367	0.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	938	2.0%
1	5	< 0.1%
2	93	0.2%
3	270	0.6%
4	1	< 0.1%
5	2319	4.9%
6	37	0.1%
7	88	0.2%
8	1	< 0.1%
9	2075	4.4%

Value	Count	Frequency (%)
21	65	0.1%
20	11	< 0.1%
19	1180	2.5%
18	238	0.5%
17	278	0.6%
16	4553	9.7%
15	52	0.1%
14	454	1.0%
13	8	< 0.1%
12	3	< 0.1%

customer_nationality
Text

Distinct	136
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	366.7 KiB

Length

Max length	32
Median length	21
Mean length	8.8196134
Min length	4

Characters and Unicode

Total characters	413878
Distinct characters	55
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	27 ?
Unique (%)	0.1%

Sample

1st row	China
2nd row	Japan
3rd row	Taiwan
4th row	Turkey
5th row	South Korea

Value	Count	Frequency (%)
south	6364	10.0%
korea	6227	9.8%
malaysia	6068	9.5%
taiwan	5059	8.0%
thailand	3409	5.4%
united	3078	4.8%
china	2669	4.2%
japan	2330	3.7%
hong	2241	3.5%
kong	2241	3.5%
Other values (151)	23912	37.6%

Most occurring characters

Value	Count	Frequency (%)
a	68559	16.6%
i	37749	9.1%
n	33947	8.2%
o	24183	5.8%
e	22684	5.5%
t	16690	4.0%
	16667	4.0%
r	14661	3.5%
s	14628	3.5%
h	14514	3.5%
Other values (45)	149596	36.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	322079	77.8%
Uppercase Letter	75123	18.2%
Space Separator	16671	4.0%
Dash Punctuation	3	< 0.1%
Other Punctuation	2	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	68559	21.3%
i	37749	11.7%
n	33947	10.5%
o	24183	7.5%
e	22684	7.0%
t	16690	5.2%
r	14661	4.6%
s	14628	4.5%
h	14514	4.5%
l	14009	4.3%
Other values (16)	60455	18.8%

Uppercase Letter

Value	Count	Frequency (%)
K	11677	15.5%
S	11036	14.7%
T	8579	11.4%
N	7190	9.6%
M	6499	8.7%
U	5347	7.1%
A	4143	5.5%
C	3152	4.2%
I	3066	4.1%
O	2363	3.1%
Other values (15)	12071	16.1%

Space Separator

Value	Count	Frequency (%)
	16667	> 99.9%
	4	< 0.1%

Dash Punctuation

Value	Count	Frequency (%)
-	3	100.0%

Other Punctuation

Value	Count	Frequency (%)
'	2	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	397202	96.0%
Common	16676	4.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	68559	17.3%
i	37749	9.5%
n	33947	8.5%
o	24183	6.1%
e	22684	5.7%
t	16690	4.2%
r	14661	3.7%
s	14628	3.7%
h	14514	3.7%
l	14009	3.5%
Other values (41)	135578	34.1%

Common

Value	Count	Frequency (%)
	16667	99.9%
	4	< 0.1%
-	3	< 0.1%
'	2	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	413874	> 99.9%
None	4	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	68559	16.6%
i	37749	9.1%
n	33947	8.2%
o	24183	5.8%
e	22684	5.5%
t	16690	4.0%
	16667	4.0%
r	14661	3.5%
s	14628	3.5%
h	14514	3.5%
Other values (44)	149592	36.1%

None

Value	Count	Frequency (%)
	4	100.0%

guest_is_not_the_customer
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	366.7 KiB

0	36872
1	10055

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	46927
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	36872	78.6%
1	10055	21.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	36872	78.6%
1	10055	21.4%

Most occurring characters

Value	Count	Frequency (%)
0	36872	78.6%
1	10055	21.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	46927	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	36872	78.6%
1	10055	21.4%

Most occurring scripts

Value	Count	Frequency (%)
Common	46927	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	36872	78.6%
1	10055	21.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	46927	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	36872	78.6%
1	10055	21.4%

guest_nationality_country_name
Text

Distinct	144
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	366.7 KiB

Length

Max length	32
Median length	26
Mean length	8.4160718
Min length	4

Characters and Unicode

Total characters	394941
Distinct characters	57
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	34 ?
Unique (%)	0.1%

Sample

1st row	China
2nd row	Japan
3rd row	Taiwan
4th row	Turkey
5th row	South Korea

Value	Count	Frequency (%)
south	6765	11.2%
korea	6634	11.0%
malaysia	6163	10.2%
taiwan	5347	8.9%
thailand	3514	5.8%
united	3211	5.3%
china	3075	5.1%
japan	2469	4.1%
hong	2287	3.8%
kong	2287	3.8%
Other values (162)	18660	30.9%

Most occurring characters

Value	Count	Frequency (%)
a	69572	17.6%
i	37621	9.5%
n	35710	9.0%
o	23356	5.9%
e	21766	5.5%
t	17532	4.4%
h	15545	3.9%
s	15086	3.8%
l	14393	3.6%
	13481	3.4%
Other values (47)	130879	33.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	321012	81.3%
Uppercase Letter	60439	15.3%
Space Separator	13485	3.4%
Other Punctuation	3	< 0.1%
Open Punctuation	1	< 0.1%
Close Punctuation	1	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	69572	21.7%
i	37621	11.7%
n	35710	11.1%
o	23356	7.3%
e	21766	6.8%
t	17532	5.5%
h	15545	4.8%
s	15086	4.7%
l	14393	4.5%
r	13380	4.2%
Other values (16)	57051	17.8%

Uppercase Letter

Value	Count	Frequency (%)
S	11588	19.2%
K	9947	16.5%
T	8986	14.9%
M	6640	11.0%
C	3587	5.9%
U	3249	5.4%
I	3217	5.3%
J	2481	4.1%
H	2298	3.8%
A	2284	3.8%
Other values (15)	6162	10.2%

Space Separator

Value	Count	Frequency (%)
	13481	> 99.9%
	4	< 0.1%

Other Punctuation

Value	Count	Frequency (%)
'	2	66.7%
&	1	33.3%

Open Punctuation

Value	Count	Frequency (%)
(	1	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	381451	96.6%
Common	13490	3.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	69572	18.2%
i	37621	9.9%
n	35710	9.4%
o	23356	6.1%
e	21766	5.7%
t	17532	4.6%
h	15545	4.1%
s	15086	4.0%
l	14393	3.8%
r	13380	3.5%
Other values (41)	117490	30.8%

Common

Value	Count	Frequency (%)
	13481	99.9%
	4	< 0.1%
'	2	< 0.1%
&	1	< 0.1%
(	1	< 0.1%
)	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	394937	> 99.9%
None	4	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	69572	17.6%
i	37621	9.5%
n	35710	9.0%
o	23356	5.9%
e	21766	5.5%
t	17532	4.4%
h	15545	3.9%
s	15086	3.8%
l	14393	3.6%
	13481	3.4%
Other values (46)	130875	33.1%

None

Value	Count	Frequency (%)
	4	100.0%

no_of_adults
Real number (ℝ)

Distinct	21
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.3475611

Minimum	1
Maximum	30
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	366.7 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	2
Q3	2
95-th percentile	4
Maximum	30
Range	29
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.3241378
Coefficient of variation (CV)	0.56404829
Kurtosis	33.488263
Mean	2.3475611
Median Absolute Deviation (MAD)	0
Skewness	4.2137414
Sum	110164
Variance	1.753341
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=21)

Value	Count	Frequency (%)
2	32070	68.3%
1	5481	11.7%
4	4492	9.6%
3	2905	6.2%
6	926	2.0%
5	378	0.8%
8	301	0.6%
10	101	0.2%
7	81	0.2%
12	67	0.1%
Other values (11)	125	0.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	5481	11.7%
2	32070	68.3%
3	2905	6.2%
4	4492	9.6%
5	378	0.8%
6	926	2.0%
7	81	0.2%
8	301	0.6%
9	49	0.1%
10	101	0.2%

Value	Count	Frequency (%)
30	1	< 0.1%
27	2	< 0.1%
20	1	< 0.1%
18	18	< 0.1%
17	2	< 0.1%
16	16	< 0.1%
15	4	< 0.1%
14	16	< 0.1%
13	3	< 0.1%
12	67	0.1%

no_of_children
Real number (ℝ)

Distinct	10
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.14814499

Minimum	0
Maximum	10
Zeros	42690
Zeros (%)	91.0%
Negative	0
Negative (%)	0.0%
Memory size	366.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	10
Range	10
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.52912642
Coefficient of variation (CV)	3.5716795
Kurtosis	25.197554
Mean	0.14814499
Median Absolute Deviation (MAD)	0
Skewness	4.4201626
Sum	6952
Variance	0.27997477
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	42690	91.0%
1	2117	4.5%
2	1726	3.7%
3	251	0.5%
4	109	0.2%
5	18	< 0.1%
6	12	< 0.1%
7	2	< 0.1%
10	1	< 0.1%
8	1	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	42690	91.0%
1	2117	4.5%
2	1726	3.7%
3	251	0.5%
4	109	0.2%
5	18	< 0.1%
6	12	< 0.1%
7	2	< 0.1%
8	1	< 0.1%
10	1	< 0.1%

Value	Count	Frequency (%)
10	1	< 0.1%
8	1	< 0.1%
7	2	< 0.1%
6	12	< 0.1%
5	18	< 0.1%
4	109	0.2%
3	251	0.5%
2	1726	3.7%
1	2117	4.5%
0	42690	91.0%

no_of_extra_bed
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	366.7 KiB

0	46416
1	483
2	22
3	5
5	1

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	46927
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	46416	98.9%
1	483	1.0%
2	22	< 0.1%
3	5	< 0.1%
5	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	46416	98.9%
1	483	1.0%
2	22	< 0.1%
3	5	< 0.1%
5	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	46416	98.9%
1	483	1.0%
2	22	< 0.1%
3	5	< 0.1%
5	1	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	46927	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	46416	98.9%
1	483	1.0%
2	22	< 0.1%
3	5	< 0.1%
5	1	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	46927	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	46416	98.9%
1	483	1.0%
2	22	< 0.1%
3	5	< 0.1%
5	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	46927	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	46416	98.9%
1	483	1.0%
2	22	< 0.1%
3	5	< 0.1%
5	1	< 0.1%

no_of_room
Real number (ℝ)

Distinct	9
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.140303

Minimum	1
Maximum	9
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	366.7 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	1
95-th percentile	2
Maximum	9
Range	8
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.51904538
Coefficient of variation (CV)	0.45518197
Kurtosis	52.885359
Mean	1.140303
Median Absolute Deviation (MAD)	0
Skewness	5.9691302
Sum	53511
Variance	0.26940811
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
1	42320	90.2%
2	3426	7.3%
3	751	1.6%
4	244	0.5%
5	106	0.2%
6	32	0.1%
9	20	< 0.1%
7	16	< 0.1%
8	12	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	42320	90.2%
2	3426	7.3%
3	751	1.6%
4	244	0.5%
5	106	0.2%
6	32	0.1%
7	16	< 0.1%
8	12	< 0.1%
9	20	< 0.1%

Value	Count	Frequency (%)
9	20	< 0.1%
8	12	< 0.1%
7	16	< 0.1%
6	32	0.1%
5	106	0.2%
4	244	0.5%
3	751	1.6%
2	3426	7.3%
1	42320	90.2%

origin_country_code
Real number (ℝ)

Distinct	142
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	88.098493

Minimum	0
Maximum	141
Zeros	66
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	366.7 KiB

Quantile statistics

Minimum	0
5-th percentile	31
Q1	62
median	94
Q3	125
95-th percentile	134
Maximum	141
Range	141
Interquartile range (IQR)	63

Descriptive statistics

Standard deviation	35.574492
Coefficient of variation (CV)	0.40380364
Kurtosis	-0.78049251
Mean	88.098493
Median Absolute Deviation (MAD)	31
Skewness	-0.37769
Sum	4134198
Variance	1265.5445
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
74	6298	13.4%
94	6185	13.2%
130	5255	11.2%
125	4308	9.2%
70	2530	5.4%
31	2494	5.3%
55	2424	5.2%
58	2263	4.8%
134	1960	4.2%
119	1926	4.1%
Other values (132)	11284	24.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	66	0.1%
1	1	< 0.1%
2	325	0.7%
3	2	< 0.1%
4	2	< 0.1%
5	3	< 0.1%
6	13	< 0.1%
7	22	< 0.1%
8	60	0.1%
9	1069	2.3%

Value	Count	Frequency (%)
141	2	< 0.1%
140	2	< 0.1%
139	2	< 0.1%
138	131	0.3%
137	1362	2.9%
136	1	< 0.1%
135	5	< 0.1%
134	1960	4.2%
133	4	< 0.1%
132	24	0.1%

language
Real number (ℝ)

Distinct	49
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	23.379462

Minimum	0
Maximum	48
Zeros	466
Zeros (%)	1.0%
Negative	0
Negative (%)	0.0%
Memory size	366.7 KiB

Quantile statistics

Minimum	0
5-th percentile	8
Q1	8
median	26
Q3	37
95-th percentile	45
Maximum	48
Range	48
Interquartile range (IQR)	29

Descriptive statistics

Standard deviation	14.699654
Coefficient of variation (CV)	0.62874219
Kurtosis	-1.4965756
Mean	23.379462
Median Absolute Deviation (MAD)	17
Skewness	0.21910009
Sum	1097128
Variance	216.07983
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=49)

Value	Count	Frequency (%)
8	17238	36.7%
27	6684	14.2%
43	5776	12.3%
37	3217	6.9%
26	2436	5.2%
45	2399	5.1%
44	1929	4.1%
16	1293	2.8%
24	765	1.6%
48	636	1.4%
Other values (39)	4554	9.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	466	1.0%
1	2	< 0.1%
2	13	< 0.1%
3	1	< 0.1%
4	17	< 0.1%
5	63	0.1%
6	148	0.3%
7	5	< 0.1%
8	17238	36.7%
9	480	1.0%

Value	Count	Frequency (%)
48	636	1.4%
47	4	< 0.1%
46	65	0.1%
45	2399	5.1%
44	1929	4.1%
43	5776	12.3%
42	90	0.2%
41	6	< 0.1%
40	9	< 0.1%
39	229	0.5%

original_selling_amount
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	26481
Distinct (%)	56.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	219.59182

Minimum	2.1
Maximum	49566.16
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	366.7 KiB

Quantile statistics

Minimum	2.1
5-th percentile	17.7
Q1	50.585
median	107.78
Q3	243.01
95-th percentile	750.268
Maximum	49566.16
Range	49564.06
Interquartile range (IQR)	192.425

Descriptive statistics

Standard deviation	439.9447
Coefficient of variation (CV)	2.0034658
Kurtosis	3515.9943
Mean	219.59182
Median Absolute Deviation (MAD)	72.27
Skewness	36.550096
Sum	10304785
Variance	193551.34
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
122.63	14	< 0.1%
15	12	< 0.1%
37.05	12	< 0.1%
22	11	< 0.1%
45	11	< 0.1%
19.56	11	< 0.1%
222.94	10	< 0.1%
28.46	10	< 0.1%
30	10	< 0.1%
16.86	10	< 0.1%
Other values (26471)	46816	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2.1	1	< 0.1%
2.27	1	< 0.1%
2.31	1	< 0.1%
2.5	1	< 0.1%
2.59	1	< 0.1%
2.64	1	< 0.1%
2.76	1	< 0.1%
2.8	1	< 0.1%
2.82	1	< 0.1%
2.9	1	< 0.1%

Value	Count	Frequency (%)
49566.16	1	< 0.1%
17942.82	1	< 0.1%
15430.5	1	< 0.1%
13015.52	1	< 0.1%
11672.15	1	< 0.1%
9562.86	1	< 0.1%
9074.52	1	< 0.1%
9065.76	1	< 0.1%
8024.56	1	< 0.1%
7437.78	1	< 0.1%

original_payment_method
Categorical

Distinct	36
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	366.7 KiB

Visa	23088
MasterCard	13875
UNKNOWN	3210
American Express	2198
JCB	1124
Other values (31)	3432

Length

Max length	21
Median length	20
Mean length	6.8831163
Min length	3

Characters and Unicode

Total characters	323004
Distinct characters	49
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	Alipay
2nd row	American Express
3rd row	Visa
4th row	MasterCard
5th row	Visa

Common Values

Value	Count	Frequency (%)
Visa	23088	49.2%
MasterCard	13875	29.6%
UNKNOWN	3210	6.8%
American Express	2198	4.7%
JCB	1124	2.4%
Alipay	945	2.0%
PayPal	557	1.2%
MayBank2U	430	0.9%
UnionPay - Creditcard	292	0.6%
K PLUS	206	0.4%
Other values (26)	1002	2.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
visa	23088	45.5%
mastercard	13875	27.3%
unknown	3210	6.3%
american	2198	4.3%
express	2198	4.3%
jcb	1124	2.2%
alipay	945	1.9%
paypal	557	1.1%
maybank2u	430	0.8%
unionpay	339	0.7%
Other values (43)	2784	5.5%

Most occurring characters

Value	Count	Frequency (%)
a	57861	17.9%
s	41874	13.0%
r	32986	10.2%
i	27345	8.5%
V	23088	7.1%
e	19220	6.0%
C	15988	4.9%
M	14788	4.6%
t	14581	4.5%
d	14574	4.5%
Other values (39)	60699	18.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	228931	70.9%
Uppercase Letter	89464	27.7%
Space Separator	3821	1.2%
Decimal Number	449	0.1%
Dash Punctuation	339	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	57861	25.3%
s	41874	18.3%
r	32986	14.4%
i	27345	11.9%
e	19220	8.4%
t	14581	6.4%
d	14574	6.4%
n	3570	1.6%
p	3303	1.4%
c	2737	1.2%
Other values (13)	10880	4.8%

Uppercase Letter

Value	Count	Frequency (%)
V	23088	25.8%
C	15988	17.9%
M	14788	16.5%
N	9652	10.8%
U	4185	4.7%
K	3449	3.9%
W	3411	3.8%
A	3382	3.8%
O	3222	3.6%
E	2248	2.5%
Other values (12)	6051	6.8%

Decimal Number

Value	Count	Frequency (%)
2	430	95.8%
7	19	4.2%

Space Separator

Value	Count	Frequency (%)
	3821	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	339	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	318395	98.6%
Common	4609	1.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	57861	18.2%
s	41874	13.2%
r	32986	10.4%
i	27345	8.6%
V	23088	7.3%
e	19220	6.0%
C	15988	5.0%
M	14788	4.6%
t	14581	4.6%
d	14574	4.6%
Other values (35)	56090	17.6%

Common

Value	Count	Frequency (%)
	3821	82.9%
2	430	9.3%
-	339	7.4%
7	19	0.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	323004	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	57861	17.9%
s	41874	13.0%
r	32986	10.2%
i	27345	8.5%
V	23088	7.1%
e	19220	6.0%
C	15988	4.9%
M	14788	4.6%
t	14581	4.5%
d	14574	4.5%
Other values (39)	60699	18.8%

original_payment_type
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	366.7 KiB

Credit Card	46132
Invoice	612
Gift Card	183

Length

Max length	11
Median length	11
Mean length	10.940035
Min length	7

Characters and Unicode

Total characters	513383
Distinct characters	15
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Credit Card
2nd row	Credit Card
3rd row	Credit Card
4th row	Credit Card
5th row	Credit Card

Common Values

Value	Count	Frequency (%)
Credit Card	46132	98.3%
Invoice	612	1.3%
Gift Card	183	0.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
card	46315	49.7%
credit	46132	49.5%
invoice	612	0.7%
gift	183	0.2%

Most occurring characters

Value	Count	Frequency (%)
C	92447	18.0%
r	92447	18.0%
d	92447	18.0%
i	46927	9.1%
e	46744	9.1%
t	46315	9.0%
	46315	9.0%
a	46315	9.0%
I	612	0.1%
n	612	0.1%
Other values (5)	2202	0.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	373826	72.8%
Uppercase Letter	93242	18.2%
Space Separator	46315	9.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
r	92447	24.7%
d	92447	24.7%
i	46927	12.6%
e	46744	12.5%
t	46315	12.4%
a	46315	12.4%
n	612	0.2%
v	612	0.2%
o	612	0.2%
c	612	0.2%

Uppercase Letter

Value	Count	Frequency (%)
C	92447	99.1%
I	612	0.7%
G	183	0.2%

Space Separator

Value	Count	Frequency (%)
	46315	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	467068	91.0%
Common	46315	9.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
C	92447	19.8%
r	92447	19.8%
d	92447	19.8%
i	46927	10.0%
e	46744	10.0%
t	46315	9.9%
a	46315	9.9%
I	612	0.1%
n	612	0.1%
v	612	0.1%
Other values (4)	1590	0.3%

Common

Value	Count	Frequency (%)
	46315	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	513383	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
C	92447	18.0%
r	92447	18.0%
d	92447	18.0%
i	46927	9.1%
e	46744	9.1%
t	46315	9.0%
	46315	9.0%
a	46315	9.0%
I	612	0.1%
n	612	0.1%
Other values (5)	2202	0.4%

original_payment_currency
Categorical

Distinct	50
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	366.7 KiB

MYR	6088
KRW	5995
TWD	5300
USD	3685
THB	3604
Other values (45)	22255

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	140781
Distinct characters	26
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	CNY
2nd row	JPY
3rd row	TWD
4th row	TRY
5th row	KRW

Common Values

Value	Count	Frequency (%)
MYR	6088	13.0%
KRW	5995	12.8%
TWD	5300	11.3%
USD	3685	7.9%
THB	3604	7.7%
CNY	2908	6.2%
HKD	2695	5.7%
JPY	2677	5.7%
SGD	1977	4.2%
IDR	1908	4.1%
Other values (40)	10090	21.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
myr	6088	13.0%
krw	5995	12.8%
twd	5300	11.3%
usd	3685	7.9%
thb	3604	7.7%
cny	2908	6.2%
hkd	2695	5.7%
jpy	2677	5.7%
sgd	1977	4.2%
idr	1908	4.1%
Other values (40)	10090	21.5%

Most occurring characters

Value	Count	Frequency (%)
D	18718	13.3%
R	17659	12.5%
Y	11789	8.4%
W	11352	8.1%
K	9238	6.6%
T	9034	6.4%
H	8063	5.7%
U	7111	5.1%
P	6972	5.0%
S	6444	4.6%
Other values (16)	34401	24.4%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	140781	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
D	18718	13.3%
R	17659	12.5%
Y	11789	8.4%
W	11352	8.1%
K	9238	6.6%
T	9034	6.4%
H	8063	5.7%
U	7111	5.1%
P	6972	5.0%
S	6444	4.6%
Other values (16)	34401	24.4%

Most occurring scripts

Value	Count	Frequency (%)
Latin	140781	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
D	18718	13.3%
R	17659	12.5%
Y	11789	8.4%
W	11352	8.1%
K	9238	6.6%
T	9034	6.4%
H	8063	5.7%
U	7111	5.1%
P	6972	5.0%
S	6444	4.6%
Other values (16)	34401	24.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	140781	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
D	18718	13.3%
R	17659	12.5%
Y	11789	8.4%
W	11352	8.1%
K	9238	6.6%
T	9034	6.4%
H	8063	5.7%
U	7111	5.1%
P	6972	5.0%
S	6444	4.6%
Other values (16)	34401	24.4%

is_user_logged_in
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	46.0 KiB

True	30549
False	16378

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
True	30549	65.1%
False	16378	34.9%

cancellation_policy_code
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	366.7 KiB

2	20542
0	13229
1	13156

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	46927
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	2
3rd row	1
4th row	0
5th row	2

Common Values

Value	Count	Frequency (%)
2	20542	43.8%
0	13229	28.2%
1	13156	28.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2	20542	43.8%
0	13229	28.2%
1	13156	28.0%

Most occurring characters

Value	Count	Frequency (%)
2	20542	43.8%
0	13229	28.2%
1	13156	28.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	46927	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	20542	43.8%
0	13229	28.2%
1	13156	28.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	46927	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	20542	43.8%
0	13229	28.2%
1	13156	28.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	46927	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	20542	43.8%
0	13229	28.2%
1	13156	28.0%

is_first_booking
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	46.0 KiB

False	36484
True	10443

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	36484	77.7%
True	10443	22.3%

request_nonesmoke
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	366.7 KiB

0.0	27599
1.0	19328

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	140781
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	27599	58.8%
1.0	19328	41.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0	27599	58.8%
1.0	19328	41.2%

Most occurring characters

Value	Count	Frequency (%)
0	74526	52.9%
.	46927	33.3%
1	19328	13.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	93854	66.7%
Other Punctuation	46927	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	74526	79.4%
1	19328	20.6%

Other Punctuation

Value	Count	Frequency (%)
.	46927	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	140781	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	74526	52.9%
.	46927	33.3%
1	19328	13.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	140781	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	74526	52.9%
.	46927	33.3%
1	19328	13.7%

request_latecheckin
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	366.7 KiB

0.0	46225
1.0	702

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	140781
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	46225	98.5%
1.0	702	1.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0	46225	98.5%
1.0	702	1.5%

Most occurring characters

Value	Count	Frequency (%)
0	93152	66.2%
.	46927	33.3%
1	702	0.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	93854	66.7%
Other Punctuation	46927	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	93152	99.3%
1	702	0.7%

Other Punctuation

Value	Count	Frequency (%)
.	46927	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	140781	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	93152	66.2%
.	46927	33.3%
1	702	0.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	140781	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	93152	66.2%
.	46927	33.3%
1	702	0.5%

request_highfloor
Categorical

HIGH CORRELATION IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	366.7 KiB

0.0	42874
1.0	4053

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	140781
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	42874	91.4%
1.0	4053	8.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0	42874	91.4%
1.0	4053	8.6%

Most occurring characters

Value	Count	Frequency (%)
0	89801	63.8%
.	46927	33.3%
1	4053	2.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	93854	66.7%
Other Punctuation	46927	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	89801	95.7%
1	4053	4.3%

Other Punctuation

Value	Count	Frequency (%)
.	46927	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	140781	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	89801	63.8%
.	46927	33.3%
1	4053	2.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	140781	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	89801	63.8%
.	46927	33.3%
1	4053	2.9%

request_largebed
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	366.7 KiB

0.0	36421
1.0	10506

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	140781
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	1.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	36421	77.6%
1.0	10506	22.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0	36421	77.6%
1.0	10506	22.4%

Most occurring characters

Value	Count	Frequency (%)
0	83348	59.2%
.	46927	33.3%
1	10506	7.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	93854	66.7%
Other Punctuation	46927	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	83348	88.8%
1	10506	11.2%

Other Punctuation

Value	Count	Frequency (%)
.	46927	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	140781	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	83348	59.2%
.	46927	33.3%
1	10506	7.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	140781	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	83348	59.2%
.	46927	33.3%
1	10506	7.5%

request_twinbeds
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	366.7 KiB

0.0	42654
1.0	4273

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	140781
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	42654	90.9%
1.0	4273	9.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0	42654	90.9%
1.0	4273	9.1%

Most occurring characters

Value	Count	Frequency (%)
0	89581	63.6%
.	46927	33.3%
1	4273	3.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	93854	66.7%
Other Punctuation	46927	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	89581	95.4%
1	4273	4.6%

Other Punctuation

Value	Count	Frequency (%)
.	46927	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	140781	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	89581	63.6%
.	46927	33.3%
1	4273	3.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	140781	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	89581	63.6%
.	46927	33.3%
1	4273	3.0%

request_airport
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	366.7 KiB

0.0	46728
1.0	199

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	140781
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	46728	99.6%
1.0	199	0.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0	46728	99.6%
1.0	199	0.4%

Most occurring characters

Value	Count	Frequency (%)
0	93655	66.5%
.	46927	33.3%
1	199	0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	93854	66.7%
Other Punctuation	46927	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	93655	99.8%
1	199	0.2%

Other Punctuation

Value	Count	Frequency (%)
.	46927	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	140781	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	93655	66.5%
.	46927	33.3%
1	199	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	140781	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	93655	66.5%
.	46927	33.3%
1	199	0.1%

request_earlycheckin
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	366.7 KiB

0.0	46026
1.0	901

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	140781
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	46026	98.1%
1.0	901	1.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0	46026	98.1%
1.0	901	1.9%

Most occurring characters

Value	Count	Frequency (%)
0	92953	66.0%
.	46927	33.3%
1	901	0.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	93854	66.7%
Other Punctuation	46927	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	92953	99.0%
1	901	1.0%

Other Punctuation

Value	Count	Frequency (%)
.	46927	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	140781	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	92953	66.0%
.	46927	33.3%
1	901	0.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	140781	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	92953	66.0%
.	46927	33.3%
1	901	0.6%

hotel_area_code
Real number (ℝ)

Distinct	5057
Distinct (%)	10.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3025.0395

Minimum	1
Maximum	5896
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	366.7 KiB

Quantile statistics

Minimum	1
5-th percentile	243
Q1	1477
median	3134
Q3	4572
95-th percentile	5602
Maximum	5896
Range	5895
Interquartile range (IQR)	3095

Descriptive statistics

Standard deviation	1733.8559
Coefficient of variation (CV)	0.573168
Kurtosis	-1.2487545
Mean	3025.0395
Median Absolute Deviation (MAD)	1549
Skewness	-0.11513251
Sum	1.4195603 × 10⁸
Variance	3006256.2
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3747	718	1.5%
1192	571	1.2%
643	419	0.9%
4463	404	0.9%
606	382	0.8%
104	372	0.8%
4364	342	0.7%
3156	335	0.7%
2553	322	0.7%
5891	302	0.6%
Other values (5047)	42760	91.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	7	< 0.1%
5	1	< 0.1%
6	5	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	7	< 0.1%
10	1	< 0.1%

Value	Count	Frequency (%)
5896	1	< 0.1%
5894	2	< 0.1%
5893	1	< 0.1%
5892	2	< 0.1%
5891	302	0.6%
5890	1	< 0.1%
5889	18	< 0.1%
5888	1	< 0.1%
5887	39	0.1%
5886	10	< 0.1%

hotel_city_code
Real number (ℝ)

Distinct	2402
Distinct (%)	5.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1498.0466

Minimum	0
Maximum	2808
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	366.7 KiB

Quantile statistics

Minimum	0
5-th percentile	140
Q1	583
median	1572
Q3	2310
95-th percentile	2797
Maximum	2808
Range	2808
Interquartile range (IQR)	1727

Descriptive statistics

Standard deviation	909.02087
Coefficient of variation (CV)	0.60680414
Kurtosis	-1.4051834
Mean	1498.0466
Median Absolute Deviation (MAD)	875
Skewness	-0.16917617
Sum	70298832
Variance	826318.94
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2477	2525	5.4%
2797	1883	4.0%
1403	1794	3.8%
142	1295	2.8%
162	1163	2.5%
2249	1124	2.4%
437	1059	2.3%
2799	987	2.1%
1816	881	1.9%
2310	767	1.6%
Other values (2392)	33449	71.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	2	< 0.1%
3	10	< 0.1%
4	2	< 0.1%
5	20	< 0.1%
6	3	< 0.1%
8	29	0.1%
9	1	< 0.1%
10	2	< 0.1%
11	1	< 0.1%

Value	Count	Frequency (%)
2808	2	< 0.1%
2807	3	< 0.1%
2806	1	< 0.1%
2805	1	< 0.1%
2804	2	< 0.1%
2803	1	< 0.1%
2802	1	< 0.1%
2800	10	< 0.1%
2799	987	2.1%
2797	1883	4.0%

has_request
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	366.7 KiB

0.0	23695
2.0	10145
1.0	10018
3.0	2622
4.0	447

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	140781
Distinct characters	6
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1.0
2nd row	0.0
3rd row	0.0
4th row	1.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	23695	50.5%
2.0	10145	21.6%
1.0	10018	21.3%
3.0	2622	5.6%
4.0	447	1.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0	23695	50.5%
2.0	10145	21.6%
1.0	10018	21.3%
3.0	2622	5.6%
4.0	447	1.0%

Most occurring characters

Value	Count	Frequency (%)
0	70622	50.2%
.	46927	33.3%
2	10145	7.2%
1	10018	7.1%
3	2622	1.9%
4	447	0.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	93854	66.7%
Other Punctuation	46927	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	70622	75.2%
2	10145	10.8%
1	10018	10.7%
3	2622	2.8%
4	447	0.5%

Other Punctuation

Value	Count	Frequency (%)
.	46927	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	140781	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	70622	50.2%
.	46927	33.3%
2	10145	7.2%
1	10018	7.1%
3	2622	1.9%
4	447	0.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	140781	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	70622	50.2%
.	46927	33.3%
2	10145	7.2%
1	10018	7.1%
3	2622	1.9%
4	447	0.3%

distance_booking_checkin
Real number (ℝ)

Distinct	30473
Distinct (%)	64.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	29.655487

Minimum	-1.6659722
Maximum	447.20972
Zeros	5
Zeros (%)	< 0.1%
Negative	7870
Negative (%)	16.8%
Memory size	366.7 KiB

Quantile statistics

Minimum	-1.6659722
5-th percentile	-0.71944444
Q1	0.62465278
median	9.8777778
Q3	37.042014
95-th percentile	132.92396
Maximum	447.20972
Range	448.87569
Interquartile range (IQR)	36.417361

Descriptive statistics

Standard deviation	46.847247
Coefficient of variation (CV)	1.579716
Kurtosis	7.9211162
Mean	29.655487
Median Absolute Deviation (MAD)	10.283333
Skewness	2.555511
Sum	1391643
Variance	2194.6646
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-0.5597222222	18	< 0.1%
-0.5256944444	16	< 0.1%
-0.625	16	< 0.1%
-0.4513888889	16	< 0.1%
-0.6902777778	16	< 0.1%
-0.4083333333	15	< 0.1%
-0.4805555556	15	< 0.1%
-0.4722222222	15	< 0.1%
0.09027777778	14	< 0.1%
-0.6243055556	14	< 0.1%
Other values (30463)	46772	99.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-1.665972222	1	< 0.1%
-1.575694444	1	< 0.1%
-1.572916667	1	< 0.1%
-1.544444444	1	< 0.1%
-1.533333333	1	< 0.1%
-1.523611111	1	< 0.1%
-1.502777778	1	< 0.1%
-1.498611111	1	< 0.1%
-1.491666667	1	< 0.1%
-1.484722222	1	< 0.1%

Value	Count	Frequency (%)
447.2097222	1	< 0.1%
361.9833333	1	< 0.1%
361.7388889	1	< 0.1%
361.4763889	1	< 0.1%
359.23125	1	< 0.1%
357.0472222	1	< 0.1%
356.2979167	1	< 0.1%
355.4930556	1	< 0.1%
353.1513889	1	< 0.1%
350.5215278	1	< 0.1%

amount_guests
Real number (ℝ)

Distinct	23
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.4957061

Minimum	1
Maximum	30
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	366.7 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	2
Q3	3
95-th percentile	5
Maximum	30
Range	29
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.4588569
Coefficient of variation (CV)	0.58454674
Kurtosis	26.962429
Mean	2.4957061
Median Absolute Deviation (MAD)	0
Skewness	3.7545332
Sum	117116
Variance	2.1282633
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=23)

Value	Count	Frequency (%)
2	29487	62.8%
4	5766	12.3%
1	5140	11.0%
3	3851	8.2%
6	1116	2.4%
5	707	1.5%
8	353	0.8%
7	125	0.3%
10	120	0.3%
9	77	0.2%
Other values (13)	185	0.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	5140	11.0%
2	29487	62.8%
3	3851	8.2%
4	5766	12.3%
5	707	1.5%
6	1116	2.4%
7	125	0.3%
8	353	0.8%
9	77	0.2%
10	120	0.3%

Value	Count	Frequency (%)
30	1	< 0.1%
27	2	< 0.1%
24	1	< 0.1%
21	1	< 0.1%
20	6	< 0.1%
18	17	< 0.1%
17	3	< 0.1%
16	16	< 0.1%
15	6	< 0.1%
14	22	< 0.1%

amount_nights
Real number (ℝ)

Distinct	29
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.993671

Minimum	1
Maximum	30
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	366.7 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	2
95-th percentile	5
Maximum	30
Range	29
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.7459906
Coefficient of variation (CV)	0.87576665
Kurtosis	44.530156
Mean	1.993671
Median Absolute Deviation (MAD)	0
Skewness	4.7506128
Sum	93557
Variance	3.0484831
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=29)

Value	Count	Frequency (%)
1	25336	54.0%
2	10657	22.7%
3	5353	11.4%
4	2625	5.6%
5	1275	2.7%
6	550	1.2%
7	513	1.1%
8	158	0.3%
10	116	0.2%
9	101	0.2%
Other values (19)	243	0.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	25336	54.0%
2	10657	22.7%
3	5353	11.4%
4	2625	5.6%
5	1275	2.7%
6	550	1.2%
7	513	1.1%
8	158	0.3%
9	101	0.2%
10	116	0.2%

Value	Count	Frequency (%)
30	11	< 0.1%
29	1	< 0.1%
28	7	< 0.1%
27	2	< 0.1%
26	2	< 0.1%
25	1	< 0.1%
23	3	< 0.1%
22	1	< 0.1%
21	10	< 0.1%
20	12	< 0.1%

price_per_guest_per_night
Real number (ℝ)

Distinct	26848
Distinct (%)	57.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	44.164547

Minimum	0.083333333
Maximum	1770.22
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	366.7 KiB

Quantile statistics

Minimum	0.083333333
5-th percentile	7.805
Q1	17.13875
median	31.22
Q3	54.9525
95-th percentile	122.70175
Maximum	1770.22
Range	1770.1367
Interquartile range (IQR)	37.81375

Descriptive statistics

Standard deviation	45.586819
Coefficient of variation (CV)	1.0322039
Kurtosis	80.290278
Mean	44.164547
Median Absolute Deviation (MAD)	16.725
Skewness	5.1722562
Sum	2072509.7
Variance	2078.1581
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6.5	16	< 0.1%
9.78	15	< 0.1%
6	14	< 0.1%
26.17	14	< 0.1%
7	13	< 0.1%
15	13	< 0.1%
122.63	13	< 0.1%
13.5	13	< 0.1%
7.5	13	< 0.1%
14.23	12	< 0.1%
Other values (26838)	46791	99.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.08333333333	1	< 0.1%
0.1923333333	1	< 0.1%
0.4233333333	1	< 0.1%
0.4875	1	< 0.1%
0.545	1	< 0.1%
0.570625	1	< 0.1%
0.6796875	1	< 0.1%
0.8333333333	1	< 0.1%
0.9225	1	< 0.1%
1	1	< 0.1%

Value	Count	Frequency (%)
1770.22	1	< 0.1%
1167.215	1	< 0.1%
915.3983333	1	< 0.1%
813.24	1	< 0.1%
739.645	1	< 0.1%
733.425	1	< 0.1%
730.28	1	< 0.1%
717.035	1	< 0.1%
715.705	1	< 0.1%
686.415	1	< 0.1%

costumer_guest_same_nation
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	46.0 KiB

False	41347
True	5580

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	41347	88.1%
True	5580	11.9%

pay_now
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	46.0 KiB

True	35335
False	11592

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
True	35335	75.3%
False	11592	24.7%

is_cancel
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	46.0 KiB

False	34250
True	12677

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	34250	73.0%
True	12677	27.0%

Auto

Heatmap
Table

	h_booking_id	booking_datetime	checkin_date	checkout_date	hotel_id	hotel_country_code	hotel_star_rating	accommadation_type_name	no_of_adults	no_of_children	no_of_room	origin_country_code	language	original_selling_amount	hotel_area_code	hotel_city_code	distance_booking_checkin	amount_guests	amount_nights	price_per_guest_per_night	guest_is_not_the_customer	no_of_extra_bed	original_payment_method	original_payment_type	original_payment_currency	is_user_logged_in	cancellation_policy_code	is_first_booking	request_nonesmoke	request_latecheckin	request_highfloor	request_largebed	request_twinbeds	request_airport	request_earlycheckin	has_request	costumer_guest_same_nation	pay_now	is_cancel
h_booking_id	1.000	0.000	-0.007	-0.007	-0.003	-0.001	0.004	0.005	0.003	0.001	0.007	-0.001	0.009	0.006	-0.000	0.002	-0.003	0.003	0.003	0.005	0.008	0.003	0.004	0.000	0.009	0.000	0.004	0.000	0.000	0.000	0.007	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.004
booking_datetime	0.000	1.000	0.648	0.637	0.049	0.067	-0.067	-0.053	-0.088	-0.105	-0.070	0.051	-0.092	-0.318	0.021	-0.017	-0.614	-0.121	-0.242	-0.202	0.048	0.020	0.048	0.028	0.085	0.113	0.076	0.026	0.251	0.041	0.043	0.178	0.065	0.050	0.034	0.142	0.066	0.282	0.265
checkin_date	-0.007	0.648	1.000	0.998	0.037	-0.009	-0.014	-0.013	-0.034	-0.044	-0.029	-0.012	-0.031	-0.076	0.008	0.003	-0.010	-0.048	-0.070	-0.029	0.014	0.008	0.020	0.013	0.056	0.011	0.017	0.012	0.182	0.020	0.024	0.122	0.051	0.014	0.021	0.098	0.016	0.026	0.021
checkout_date	-0.007	0.637	0.998	1.000	0.036	-0.014	-0.013	-0.013	-0.035	-0.043	-0.028	-0.018	-0.035	-0.044	0.007	0.004	0.006	-0.049	-0.019	-0.023	0.016	0.011	0.023	0.016	0.055	0.015	0.016	0.006	0.181	0.020	0.021	0.120	0.051	0.012	0.019	0.097	0.009	0.023	0.022
hotel_id	-0.003	0.049	0.037	0.036	1.000	0.071	-0.171	-0.154	-0.022	-0.048	-0.031	0.064	0.032	-0.110	0.006	0.026	-0.034	-0.038	-0.021	-0.118	0.041	0.028	0.066	0.062	0.067	0.058	0.160	0.022	0.021	0.014	0.026	0.029	0.022	0.004	0.014	0.023	0.035	0.163	0.117
hotel_country_code	-0.001	0.067	-0.009	-0.014	0.071	1.000	-0.077	0.027	0.105	0.003	0.004	0.475	0.132	-0.176	0.013	0.067	-0.106	0.095	-0.074	-0.243	0.107	0.023	0.144	0.103	0.463	0.075	0.208	0.096	0.041	0.059	0.040	0.097	0.021	0.018	0.042	0.044	0.144	0.212	0.200
hotel_star_rating	0.004	-0.067	-0.014	-0.013	-0.171	-0.077	1.000	0.328	0.094	0.078	0.036	-0.099	0.008	0.445	-0.002	-0.024	0.112	0.115	0.060	0.509	0.048	0.021	0.100	0.055	0.108	0.029	0.101	0.038	0.023	0.011	0.132	0.089	0.072	0.028	0.045	0.072	0.037	0.096	0.051
accommadation_type_name	0.005	-0.053	-0.013	-0.013	-0.154	0.027	0.328	1.000	0.152	0.063	0.030	-0.007	-0.013	0.222	-0.017	-0.001	0.069	0.158	0.016	0.215	0.045	0.028	0.055	0.022	0.086	0.022	0.087	0.040	0.043	0.016	0.071	0.049	0.046	0.026	0.023	0.041	0.033	0.046	0.062
no_of_adults	0.003	-0.088	-0.034	-0.035	-0.022	0.105	0.094	0.152	1.000	0.047	0.529	0.089	0.016	0.258	0.012	0.013	0.119	0.903	0.010	-0.100	0.032	0.106	0.000	0.019	0.036	0.018	0.027	0.008	0.022	0.000	0.009	0.069	0.058	0.022	0.000	0.014	0.008	0.059	0.045
no_of_children	0.001	-0.105	-0.044	-0.043	-0.048	0.003	0.078	0.063	0.047	1.000	0.064	-0.009	0.058	0.161	-0.018	0.017	0.125	0.432	0.049	-0.015	0.020	0.037	0.025	0.007	0.044	0.006	0.016	0.038	0.017	0.006	0.008	0.046	0.019	0.011	0.020	0.011	0.014	0.091	0.043
no_of_room	0.007	-0.070	-0.029	-0.028	-0.031	0.004	0.036	0.030	0.529	0.064	1.000	0.016	0.015	0.219	-0.005	-0.011	0.085	0.499	0.034	0.008	0.044	0.102	0.008	0.010	0.035	0.020	0.006	0.008	0.011	0.000	0.007	0.031	0.053	0.022	0.000	0.005	0.021	0.047	0.027
origin_country_code	-0.001	0.051	-0.012	-0.018	0.064	0.475	-0.099	-0.007	0.089	-0.009	0.016	1.000	0.095	-0.131	0.020	0.021	-0.102	0.075	-0.092	-0.154	0.131	0.020	0.225	0.310	0.806	0.079	0.101	0.119	0.079	0.051	0.091	0.109	0.058	0.032	0.051	0.065	0.219	0.137	0.141
language	0.009	-0.092	-0.031	-0.035	0.032	0.132	0.008	-0.013	0.016	0.058	0.015	0.095	1.000	0.043	-0.034	-0.040	0.124	0.036	-0.067	0.088	0.127	0.015	0.241	0.286	0.672	0.150	0.104	0.132	0.096	0.065	0.048	0.127	0.044	0.029	0.070	0.069	0.144	0.168	0.131
original_selling_amount	0.006	-0.318	-0.076	-0.044	-0.110	-0.176	0.445	0.222	0.258	0.161	0.219	-0.131	0.043	1.000	-0.032	-0.042	0.458	0.298	0.612	0.752	0.013	0.000	0.000	0.000	0.034	0.000	0.004	0.000	0.010	0.000	0.000	0.000	0.000	0.013	0.000	0.000	0.000	0.013	0.018
hotel_area_code	-0.000	0.021	0.008	0.007	0.006	0.013	-0.002	-0.017	0.012	-0.018	-0.005	0.020	-0.034	-0.032	1.000	0.013	-0.020	0.006	-0.000	-0.044	0.050	0.011	0.037	0.100	0.078	0.035	0.049	0.024	0.019	0.019	0.033	0.013	0.017	0.021	0.006	0.016	0.015	0.041	0.033
hotel_city_code	0.002	-0.017	0.003	0.004	0.026	0.067	-0.024	-0.001	0.013	0.017	-0.011	0.021	-0.040	-0.042	0.013	1.000	0.017	0.017	0.009	-0.070	0.061	0.015	0.055	0.095	0.172	0.040	0.108	0.053	0.014	0.022	0.034	0.017	0.004	0.019	0.028	0.022	0.057	0.072	0.053
distance_booking_checkin	-0.003	-0.614	-0.010	0.006	-0.034	-0.106	0.112	0.069	0.119	0.125	0.085	-0.102	0.124	0.458	-0.020	0.017	1.000	0.158	0.343	0.309	0.045	0.008	0.040	0.027	0.081	0.122	0.075	0.030	0.174	0.031	0.047	0.130	0.040	0.042	0.024	0.101	0.061	0.289	0.279
amount_guests	0.003	-0.121	-0.048	-0.049	-0.038	0.095	0.115	0.158	0.903	0.432	0.499	0.075	0.036	0.298	0.006	0.017	0.158	1.000	0.029	-0.099	0.030	0.116	0.000	0.024	0.039	0.014	0.033	0.030	0.024	0.000	0.011	0.085	0.061	0.020	0.000	0.017	0.013	0.096	0.059
amount_nights	0.003	-0.242	-0.070	-0.019	-0.021	-0.074	0.060	0.016	0.010	0.049	0.034	-0.092	-0.067	0.612	-0.000	0.009	0.343	0.029	1.000	0.134	0.032	0.000	0.007	0.012	0.088	0.018	0.014	0.034	0.032	0.010	0.040	0.014	0.009	0.044	0.000	0.022	0.033	0.095	0.112
price_per_guest_per_night	0.005	-0.202	-0.029	-0.023	-0.118	-0.243	0.509	0.215	-0.100	-0.015	0.008	-0.154	0.088	0.752	-0.044	-0.070	0.309	-0.099	0.134	1.000	0.015	0.000	0.000	0.079	0.036	0.013	0.036	0.000	0.018	0.008	0.000	0.013	0.010	0.000	0.000	0.013	0.020	0.028	0.041
guest_is_not_the_customer	0.008	0.048	0.014	0.016	0.041	0.107	0.048	0.045	0.032	0.020	0.044	0.131	0.127	0.013	0.050	0.061	0.045	0.030	0.032	0.015	1.000	0.014	0.079	0.082	0.199	0.046	0.018	0.162	0.051	0.008	0.000	0.027	0.048	0.002	0.015	0.065	0.044	0.044	0.046
no_of_extra_bed	0.003	0.020	0.008	0.011	0.028	0.023	0.021	0.028	0.106	0.037	0.102	0.020	0.015	0.000	0.011	0.015	0.008	0.116	0.000	0.000	0.014	1.000	0.000	0.000	0.047	0.000	0.015	0.013	0.000	0.013	0.000	0.016	0.027	0.035	0.012	0.000	0.000	0.034	0.000
original_payment_method	0.004	0.048	0.020	0.023	0.066	0.144	0.100	0.055	0.000	0.025	0.008	0.225	0.241	0.000	0.037	0.055	0.040	0.000	0.007	0.000	0.079	0.000	1.000	0.341	0.163	0.123	0.115	0.096	0.080	0.027	0.078	0.115	0.058	0.009	0.036	0.072	0.096	0.237	0.148
original_payment_type	0.000	0.028	0.013	0.016	0.062	0.103	0.055	0.022	0.019	0.007	0.010	0.310	0.286	0.000	0.100	0.095	0.027	0.024	0.012	0.079	0.082	0.000	0.341	1.000	0.316	0.163	0.031	0.053	0.096	0.013	0.036	0.062	0.036	0.004	0.015	0.081	0.041	0.068	0.053
original_payment_currency	0.009	0.085	0.056	0.055	0.067	0.463	0.108	0.086	0.036	0.044	0.035	0.806	0.672	0.034	0.078	0.172	0.081	0.039	0.088	0.036	0.199	0.047	0.163	0.316	1.000	0.199	0.135	0.218	0.099	0.068	0.153	0.147	0.074	0.117	0.090	0.097	0.394	0.205	0.177
is_user_logged_in	0.000	0.113	0.011	0.015	0.058	0.075	0.029	0.022	0.018	0.006	0.020	0.079	0.150	0.000	0.035	0.040	0.122	0.014	0.018	0.013	0.046	0.000	0.123	0.163	0.199	1.000	0.046	0.479	0.034	0.032	0.072	0.044	0.018	0.000	0.036	0.092	0.032	0.096	0.095
cancellation_policy_code	0.004	0.076	0.017	0.016	0.160	0.208	0.101	0.087	0.027	0.016	0.006	0.101	0.104	0.004	0.049	0.108	0.075	0.033	0.014	0.036	0.018	0.015	0.115	0.031	0.135	0.046	1.000	0.025	0.030	0.004	0.020	0.066	0.017	0.012	0.022	0.044	0.033	0.358	0.313
is_first_booking	0.000	0.026	0.012	0.006	0.022	0.096	0.038	0.040	0.008	0.038	0.008	0.119	0.132	0.000	0.024	0.053	0.030	0.030	0.034	0.000	0.162	0.013	0.096	0.053	0.218	0.479	0.025	1.000	0.041	0.025	0.044	0.039	0.022	0.024	0.026	0.076	0.179	0.038	0.012
request_nonesmoke	0.000	0.251	0.182	0.181	0.021	0.041	0.023	0.043	0.022	0.017	0.011	0.079	0.096	0.010	0.019	0.014	0.174	0.024	0.032	0.018	0.051	0.000	0.080	0.096	0.099	0.034	0.030	0.041	1.000	0.046	0.217	0.391	0.242	0.029	0.060	0.861	0.020	0.021	0.059
request_latecheckin	0.000	0.041	0.020	0.020	0.014	0.059	0.011	0.016	0.000	0.006	0.000	0.051	0.065	0.000	0.019	0.022	0.031	0.000	0.010	0.008	0.008	0.013	0.027	0.013	0.068	0.032	0.004	0.025	0.046	1.000	0.136	0.084	0.021	0.005	0.016	0.332	0.007	0.019	0.018
request_highfloor	0.007	0.043	0.024	0.021	0.026	0.040	0.132	0.071	0.009	0.008	0.007	0.091	0.048	0.000	0.033	0.034	0.047	0.011	0.040	0.000	0.000	0.000	0.078	0.036	0.153	0.072	0.020	0.044	0.217	0.136	1.000	0.253	0.115	0.044	0.195	0.766	0.010	0.035	0.010
request_largebed	0.000	0.178	0.122	0.120	0.029	0.097	0.089	0.049	0.069	0.046	0.031	0.109	0.127	0.000	0.013	0.017	0.130	0.085	0.014	0.013	0.027	0.016	0.115	0.062	0.147	0.044	0.066	0.039	0.391	0.084	0.253	1.000	0.170	0.041	0.090	0.680	0.000	0.042	0.082
request_twinbeds	0.000	0.065	0.051	0.051	0.022	0.021	0.072	0.046	0.058	0.019	0.053	0.058	0.044	0.000	0.017	0.004	0.040	0.061	0.009	0.010	0.048	0.027	0.058	0.036	0.074	0.018	0.017	0.022	0.242	0.021	0.115	0.170	1.000	0.008	0.039	0.400	0.000	0.020	0.008
request_airport	0.000	0.050	0.014	0.012	0.004	0.018	0.028	0.026	0.022	0.011	0.022	0.032	0.029	0.013	0.021	0.019	0.042	0.020	0.044	0.000	0.002	0.035	0.009	0.004	0.117	0.000	0.012	0.024	0.029	0.005	0.044	0.041	0.008	1.000	0.006	0.165	0.010	0.016	0.000
request_earlycheckin	0.000	0.034	0.021	0.019	0.014	0.042	0.045	0.023	0.000	0.020	0.000	0.051	0.070	0.000	0.006	0.028	0.024	0.000	0.000	0.000	0.015	0.012	0.036	0.015	0.090	0.036	0.022	0.026	0.060	0.016	0.195	0.090	0.039	0.006	1.000	0.423	0.000	0.000	0.007
has_request	0.000	0.142	0.098	0.097	0.023	0.044	0.072	0.041	0.014	0.011	0.005	0.065	0.069	0.000	0.016	0.022	0.101	0.017	0.022	0.013	0.065	0.000	0.072	0.081	0.097	0.092	0.044	0.076	0.861	0.332	0.766	0.680	0.400	0.165	0.423	1.000	0.012	0.058	0.083
costumer_guest_same_nation	0.000	0.066	0.016	0.009	0.035	0.144	0.037	0.033	0.008	0.014	0.021	0.219	0.144	0.000	0.015	0.057	0.061	0.013	0.033	0.020	0.044	0.000	0.096	0.041	0.394	0.032	0.033	0.179	0.020	0.007	0.010	0.000	0.000	0.010	0.000	0.012	1.000	0.047	0.018
pay_now	0.000	0.282	0.026	0.023	0.163	0.212	0.096	0.046	0.059	0.091	0.047	0.137	0.168	0.013	0.041	0.072	0.289	0.096	0.095	0.028	0.044	0.034	0.237	0.068	0.205	0.096	0.358	0.038	0.021	0.019	0.035	0.042	0.020	0.016	0.000	0.058	0.047	1.000	0.387
is_cancel	0.004	0.265	0.021	0.022	0.117	0.200	0.051	0.062	0.045	0.043	0.027	0.141	0.131	0.018	0.033	0.053	0.279	0.059	0.112	0.041	0.046	0.000	0.148	0.053	0.177	0.095	0.313	0.012	0.059	0.018	0.010	0.082	0.008	0.000	0.007	0.083	0.018	0.387	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	h_booking_id	booking_datetime	checkin_date	checkout_date	hotel_id	hotel_country_code	hotel_live_date	hotel_star_rating	accommadation_type_name	customer_nationality	guest_nationality_country_name	no_of_adults	no_of_room	origin_country_code	language	original_selling_amount	original_payment_method	original_payment_type	original_payment_currency	is_user_logged_in	cancellation_policy_code	is_first_booking	request_nonesmoke	request_largebed	request_twinbeds	request_earlycheckin	hotel_area_code	hotel_city_code	has_request	distance_booking_checkin	amount_guests	amount_nights	price_per_guest_per_night	costumer_guest_same_nation	pay_now	is_cancel
0	7861445258918608962	294	212	213	88838	5.0	2012-10-04 10:03:00	4.0	16.0	China	China	12	2	31.0	37.0	436.52	Alipay	Credit Card	CNY	True	1	False	1.0	0.0	0.0	0.0	5832	461	1.0	282.190278	12	1.0	36.376667	False	True	False
1	-3175925110616170919	222	222	223	51920	57.0	2012-10-01 10:03:00	3.0	10.0	Japan	Japan	1	1	70.0	26.0	54.01	American Express	Credit Card	JPY	True	2	False	0.0	0.0	0.0	0.0	643	2249	0.0	-0.652778	1	1.0	54.010000	False	True	False
2	-5166200042028380517	257	257	258	90189	114.0	2014-06-12 08:05:00	4.0	10.0	Taiwan	Taiwan	2	1	130.0	43.0	99.18	Visa	Credit Card	TWD	True	1	False	0.0	0.0	0.0	0.0	2900	892	0.0	-0.913889	2	1.0	49.590000	False	True	False
3	6165211278500849566	256	256	257	236389	113.0	2010-08-31 07:16:00	0.0	5.0	Turkey	Turkey	1	1	129.0	46.0	19.36	MasterCard	Credit Card	TRY	False	0	False	0.0	1.0	0.0	0.0	3110	744	1.0	-0.565278	1	1.0	19.360000	False	True	False
4	-1853092131420973567	32	243	245	187085	57.0	2010-07-01 07:38:00	3.5	10.0	South Korea	South Korea	1	1	74.0	27.0	175.52	Visa	Credit Card	KRW	True	2	False	0.0	0.0	0.0	0.0	3760	2260	0.0	210.136111	1	2.0	87.760000	False	False	True
5	8478973924173415354	172	196	198	788472	109.0	2015-01-15 15:54:00	3.0	10.0	South Korea	South Korea	2	1	74.0	27.0	68.38	UnionPay - Creditcard	Credit Card	KRW	False	0	False	0.0	0.0	0.0	0.0	1709	1636	0.0	23.031944	2	2.0	17.095000	False	True	False
6	-1853437799368162580	208	231	233	1634464	109.0	2016-12-19 12:24:00	3.5	10.0	South Korea	South Korea	1	1	74.0	8.0	163.60	Visa	Credit Card	KRW	True	1	False	1.0	0.0	0.0	1.0	2964	2477	2.0	22.692361	1	2.0	81.800000	False	False	True
7	259359728717957150	205	222	225	3002333	109.0	2017-11-11 20:57:00	2.0	10.0	Thailand	Thailand	2	1	125.0	45.0	48.54	Visa	Credit Card	THB	False	1	False	1.0	1.0	0.0	0.0	2964	2477	2.0	16.167361	2	3.0	8.090000	False	False	False
8	-1624588124260700023	237	258	260	1160850	61.0	2016-01-27 12:39:00	3.0	10.0	South Korea	South Korea	3	1	74.0	27.0	119.11	UnionPay - Creditcard	Credit Card	KRW	False	2	True	1.0	0.0	1.0	0.0	3901	2459	2.0	20.722917	3	2.0	19.851667	False	True	True
9	8703485699898329335	113	230	231	304893	38.0	2010-11-17 07:09:00	3.5	10.0	China	China	2	1	31.0	37.0	87.78	UNKNOWN	Invoice	CNY	False	2	True	0.0	0.0	0.0	0.0	4806	2745	0.0	116.028472	2	1.0	43.890000	False	True	False

	h_booking_id	booking_datetime	checkin_date	checkout_date	hotel_id	hotel_country_code	hotel_live_date	hotel_star_rating	accommadation_type_name	customer_nationality	guest_is_not_the_customer	guest_nationality_country_name	no_of_adults	no_of_room	origin_country_code	language	original_selling_amount	original_payment_method	original_payment_type	original_payment_currency	is_user_logged_in	cancellation_policy_code	is_first_booking	request_nonesmoke	request_largebed	hotel_area_code	hotel_city_code	has_request	distance_booking_checkin	amount_guests	amount_nights	price_per_guest_per_night	costumer_guest_same_nation	pay_now	is_cancel
46917	-3955370707847627756	147	186	189	289317	45.0	2011-10-26 16:50:00	1.0	9.0	China	0	China	2	1	31.0	37.0	116.77	WeChat	Credit Card	CNY	True	0	False	0.0	0.0	5262	142	0.0	38.468056	2	3.0	19.461667	False	True	False
46918	-7280254002553494006	80	270	271	196931	57.0	2011-06-29 10:05:00	4.0	10.0	South Korea	0	South Korea	1	1	74.0	27.0	196.43	MasterCard	Credit Card	KRW	True	2	False	0.0	0.0	2722	1335	0.0	189.234028	1	1.0	196.430000	False	False	True
46919	8038861849194051967	32	243	245	812762	57.0	2015-03-11 14:43:00	3.0	10.0	South Korea	0	South Korea	1	1	74.0	27.0	132.78	Visa	Credit Card	KRW	False	2	True	0.0	0.0	3760	2260	0.0	210.143056	1	2.0	66.390000	False	False	True
46920	-5687848489097746853	180	215	218	868632	57.0	2015-02-26 16:35:00	1.0	9.0	South Korea	0	South Korea	1	1	74.0	27.0	87.01	Visa	Credit Card	KRW	True	2	False	0.0	0.0	3950	220	0.0	34.154861	1	3.0	29.003333	False	True	True
46921	4805148141901219862	173	245	247	3132844	61.0	2017-11-06 16:47:00	3.0	10.0	Taiwan	0	Taiwan	3	1	130.0	43.0	183.54	Visa	Credit Card	TWD	True	2	False	0.0	0.0	5242	731	0.0	71.735417	3	2.0	30.590000	False	True	False
46922	7859361556233200164	258	259	260	2504240	57.0	2017-07-08 14:23:00	3.0	18.0	Japan	0	Japan	2	1	70.0	26.0	142.68	UNKNOWN	Credit Card	JPY	False	2	True	1.0	1.0	185	2039	2.0	0.063194	2	1.0	71.340000	False	True	False
46923	2778941468684758600	265	270	272	2613173	57.0	2017-08-15 07:07:00	2.0	5.0	South Korea	0	South Korea	1	1	74.0	27.0	49.74	MasterCard	Credit Card	KRW	True	1	False	0.0	0.0	4463	2567	0.0	4.054167	1	2.0	24.870000	False	True	True
46924	-8952794303652718161	95	203	205	276008	61.0	2014-06-19 08:05:00	3.5	10.0	Taiwan	0	Taiwan	3	1	130.0	43.0	140.12	Visa	Credit Card	TWD	True	2	False	0.0	0.0	1240	731	0.0	107.054861	3	2.0	23.353333	False	False	True
46925	-4286304901316077629	212	213	215	1573295	114.0	2016-10-04 13:32:00	3.0	10.0	Taiwan	1	Taiwan	2	1	130.0	43.0	87.30	MasterCard	Credit Card	TWD	True	2	False	1.0	0.0	5208	2004	1.0	0.458333	2	2.0	21.825000	False	True	False
46926	8516014471330804625	207	241	242	91737	52.0	2009-06-28 02:02:00	3.5	10.0	Bangladesh	1	Bangladesh	2	1	12.0	8.0	58.01	MasterCard	Credit Card	USD	True	2	False	0.0	1.0	2597	2302	1.0	33.340278	2	1.0	29.005000	False	False	False

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Dash Punctuation

Other Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

None

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Other Punctuation

Open Punctuation

Close Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

None

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Space Separator

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length